<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_category`;");
E_C("CREATE TABLE `ecs_category` (
  `cat_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `cat_name` varchar(90) NOT NULL DEFAULT '',
  `keywords` varchar(255) NOT NULL DEFAULT '',
  `cat_desc` varchar(255) NOT NULL DEFAULT '',
  `parent_id` smallint(5) unsigned NOT NULL DEFAULT '0',
  `sort_order` tinyint(1) unsigned NOT NULL DEFAULT '50',
  `template_file` varchar(50) NOT NULL DEFAULT '',
  `measure_unit` varchar(15) NOT NULL DEFAULT '',
  `show_in_nav` tinyint(1) NOT NULL DEFAULT '0',
  `style` varchar(150) NOT NULL,
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `grade` tinyint(4) NOT NULL DEFAULT '0',
  `filter_attr` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cat_id`),
  KEY `parent_id` (`parent_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_category` values('1','系列','','','0','1','','','0','','1','0','');");
E_D("replace into `ecs_category` values('2','品牌','','','0','2','','','0','','1','0','');");
E_D("replace into `ecs_category` values('3','服务','','','0','3','','','0','','1','0','');");
E_D("replace into `ecs_category` values('4','精油','','','1','1','','','0','','1','0','');");
E_D("replace into `ecs_category` values('5','香水','','','1','2','','','0','','1','0','');");
E_D("replace into `ecs_category` values('6','熏香','','','1','3','','','0','','1','0','');");
E_D("replace into `ecs_category` values('7','皇室宫廷系列','','','4','1','','','0','','1','0','');");
E_D("replace into `ecs_category` values('8','皇室花香系列','','','4','2','','','0','','1','0','');");
E_D("replace into `ecs_category` values('9','皇室四时系列','','','4','3','','','0','','1','0','');");
E_D("replace into `ecs_category` values('10','皇家单方系列','','','4','4','','','0','','1','0','');");
E_D("replace into `ecs_category` values('11','十八香词系列之男香','','','5','1','','','0','','1','0','');");
E_D("replace into `ecs_category` values('12','十八香词系列之女香','','','5','2','','','0','','1','0','');");
E_D("replace into `ecs_category` values('13','皇室熏香系列','','','6','1','','','0','','1','0','');");
E_D("replace into `ecs_category` values('14','服饰','服饰','服饰','1','50','','','0','','1','0','');");
E_D("replace into `ecs_category` values('15','世袭传奇','世袭传奇','世袭传奇','1','50','','','0','','1','0','');");
E_D("replace into `ecs_category` values('16','养生酒','养生酒','养生酒','1','50','','','0','','1','0','');");
E_D("replace into `ecs_category` values('17','欲为人母','','','7','1','','','0','','1','0','9');");
E_D("replace into `ecs_category` values('18','初为人母','','','7','50','','','0','','1','0','9');");

require("../../inc/footer.php");
?>